DELETE FROM [PipeDiameterType];

DBCC CHECKIDENT ([PipeDiameterType], RESEED, 0);

INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('1/8','',0.405,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('1/4','',0.54,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('3/8','',0.675,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('1/2','',0.84,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('3/4','',1.05,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('1','',1.315,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('1 1/4','',1.66,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('1 1/2','',1.9,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('2','',2.375,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('2 1/2','',2.875,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('3','',3.5,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('3 1/2','',4,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('4','',4.5,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('4 1/2','',5,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('5','',5.563,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('6','',6.625,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('7','',7.625,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('8','',8.625,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('9','',9.625,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('10','',10.75,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('11','',11.75,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('12','',12.75,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('14','',14,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('16','',16,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('18','',18,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('20','',20,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('22','',22,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('24','',24,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('26','',26,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('28','',28,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('30','',30,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('32','',32,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('34','',34,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('36','',36,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('38','',38,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('40','',40,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('42','',42,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('44','',44,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('46','',46,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('48','',48,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('50','',50,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('52','',52,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('54','',54,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('56','',56,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('60','',60,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('64','',64,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('68','',68,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('72','',72,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('76','',76,'A','admin',GETDATE());
INSERT INTO [dbo].[PipeDiameterType]([ShortName],[Description],[ExternalDiameterInches],[Active],[Creator],[Created]) VALUES('80','',80,'A','admin',GETDATE());

SELECT * FROM [PipeDiameterType];